RIQ and Journals calculation

Automatic Replenishment covers all steps from calculating Out-of-Stock, current inventory and demand, journals, thresholds until finally creating the Purchase Orders, Transfer Orders or Sales Orders.

The Replenishment Item Quantity (RIQ) and Replenishment Journal calculation reuses pre-calculated Out-of-Stock occurrences and calculates the proposals for purchases and transfers.
This is done in two separate steps:

  • Replenishment Item Quantity calculation
  • Replenishment Journal calculation

 

Replenishment Item Quantity calculation
The Replenishment Item Quantity (RIQ) table is used to store a snapshot of the current stock situation of the items in the stores and warehouses. This table is usually calculated once per day in a nightly Scheduler Job run and is the basis for the calculation of the Replenishment Journals. The RIQ can be calculated with parallel processes to reduce calculation time.
If the Out of Stock days should be considered in the Replenishment Item Quantity calculation, the Out of Stock table needs to be calculated upfront.

Replenishment Journal calculation
Replenishment Journals are used to calculate the Purchase Order and Transfer Order proposals for Replenishment based on the current stock situation and the demand in the stores. The calculation of the journals depends on the Replenishment Item Quantity table, which needs to be calculated upfront.

Each Journal has a Template and a Batch:

  • The Template defines what should be calculated in the Journal and it provides filters for items, stores, vendors, and more.
  • The Batch defines when the Journal should be calculated.

Refer to the topics Replenishment Templates and Replenishment Batchfor a more detailed description of the fields in these tables.

 

Goal

The goals of this step:

  • Get an understanding how to set up RIQ calculation and Journals
  • Set up the processes for the calculation in LS Central

 

Key questions / considerations

Replenishment Item Quantity

  • Is Automatic Replenishment used for one or more items?
  • Should RIQ be pre-calculated in the night or calculated on the fly when calculating journals manually?

Replenishment Journals

  • Is Automatic Replenishment used for one or more items?
  • Should Journals be pre-calculated in the night or calculated manually by the user?
  • How shall Replenishment Journals be grouped?
    • Vendors
    • Product Groups
    • Stores

    (see Item Flow for details, how the Item Flow defines the Replenishment Journal setup)

  • Which fields should be visible in Journals?
    • Quantity fields
    • Sales amount fields
    • Cost amount fields
    • Profit amount fields

Setup

  • When should Scheduler jobs for calculation be run?
  • How many SKU's (item, variant and location combinations) need to be calculated?
    • If this is exceeding 1mio. SKU's

      or calculation time is too long:
      • Activate query-based processing for RIQ calculation
      • Activate parallel processing for RIQ calculation

 

Setup considerations

Replenishment Item Quantity calculation

The Replenishment Item Quantity can be calculated manually or via a Scheduler Job - it is best practice to run this in a nightly job.
Information how to run the calculation can be found here: Calculation of the Replenishment Item Quantity table.

The Replenishment Item Quantity needs to be calculated before the Journals are calculated.

Replenishment Journals

In the Replenishment Journals it is possible to set up which fields are visible in the Journal lines.
This is used, when sensitive information (like cost prices) should not be shown to specific users or user groups.

Activate or deactivate the relevant fields on the Replenishment Template page, FastTab Visible Fields.

Replenishment Journal calculation

The Replenishment Journals can be calculated manually or via a Scheduler Job - it is best practice to run this in a nightly job. If a Journal needs to be recalculated during the day this can be done manually from the Replen. Journal page.

Information how to run the calculation manually can be found here: Replenishment Journals
To calculate the Journal with the Scheduler a Replen. Journal Batch needs to be set up. Information how to set up Journal Batches can be found here: Replenishment Batch

Scheduler Jobs

The Scheduler Jobs for Replenishment need to run in a specific order

  1. Out of Stock calculation (if applicable)
    Job REPLEN-STKOUT in LS Central demo database
  2. Replenishment Item Quantity
    Job REPLEN-QTY in LS Central demo database
  3. Replenishment Journals
    Job REPLEN-RUN in LS Central demo database

Performance tuning

The calculation time of the RIQ and Journals calculation are directly dependent from the number of items, variants and locations to be calculated. Calculation times of one hour or more are not unusual and while calculating no other Scheduler jobs or database maintenance should occur at the same time. If the calculation takes too long, calculation performance can be improved.

To improve the calculation performance of the RIQ table there are two options:

  • Query based processing
  • Parallel processing

Both options can be used together, if needed.

Query based processing:
This can be enabled in the the Replen. Setup page by activating the Replenishment Item Quantity - Enable Query field. When this is enabled, the calculation will make use of Business Central query objects and temporary tables. This will consume more physical RAM memory on the service tier as the standard calculation approach but will reduce calculation time.

Parallel processing:

The calculation can be split between multiple service tiers where each service tier will only calculate a part of the entire item scope. The service tiers can be run on the same VM or server.

More details, how to setup the parallel calculation approach can be found here: Replenishment Calculation using Multiple NAS LS Nav 2017 (10.06) Memo.pdf

 

Go back to:

Automatic Replenishment

Processes

Overview